[dbo].[UniformDistribution]

Property	Value
Row Count	0
Created	10:31:41 AM Tuesday, March 02, 2010
Last Modified	11:40:10 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:41 AM Tuesday, March 02, 2010

Last Modified

11:40:10 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_UniformDistribution: UniformKey\UserKey$	UniformKey	uniqueidentifier	16
$Cluster Primary Key PK_UniformDistribution: UniformKey\UserKey$	UserKey	uniqueidentifier	16
	EffectiveDate	datetime	8
	ExpirationDate	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_UniformDistribution: UniformKey\UserKey$

UniformKey

uniqueidentifier

$Cluster Primary Key PK_UniformDistribution: UniformKey\UserKey$

UserKey

uniqueidentifier

EffectiveDate

datetime

ExpirationDate

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_UniformDistribution: UniformKey\UserKey$	PK_UniformDistribution	UniformKey, UserKey

Name

Columns

Unique

$Cluster Primary Key PK_UniformDistribution: UniformKey\UserKey$

PK_UniformDistribution

UniformKey, UserKey

Name	Columns
FK_UniformDistribution_UserMain	UserKey->[dbo].[UserMain].[UserKey]

Name

Columns

FK_UniformDistribution_UserMain

UserKey->[dbo].[UserMain].[UserKey]

SQL Script

CREATE TABLE [dbo].[UniformDistribution]
(
[UniformKey] [uniqueidentifier] NOT NULL,
[UserKey] [uniqueidentifier] NOT NULL,
[EffectiveDate] [datetime] NULL,
[ExpirationDate] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UniformDistribution] ADD CONSTRAINT [PK_UniformDistribution] PRIMARY KEY CLUSTERED ([UniformKey], [UserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UniformDistribution] ADD CONSTRAINT [FK_UniformDistribution_UserMain] FOREIGN KEY ([UserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO